﻿CREATE TABLE [dbo].[ReceivableRecurring] (
    [ID_ReceivableRecurring] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Client]              INT           NOT NULL,
    [DocumentNumber]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Description]            VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NOT NULL,
    [Id_RecurringType]       INT           NOT NULL,
    [StartDate]              SMALLDATETIME NOT NULL,
    [FinalDate]              SMALLDATETIME NULL,
    [Id_CostCenter]          INT           NULL,
    [Id_Account]             INT           NOT NULL,
    [Amount]                 MONEY         NULL
);

